Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
CustomerAccountInvoiceID (PK) | A unique system assigned identifier for the CustomerAccountInvoice | ID_INVC_CTAC | Identity | integer | |
ReportingPeriodID (FK) | The unique system assigned identifier for a particular ReportingPeriod. | ID_PRD_RP | Identity | integer | ReportingPeriod(CA_PRD_RP) |
InvoiceContent | An electronic copy of the CustomerAccountInvoice. This element may contain PDF file image, bitmap image, or HTML source for the invoice. | BM_INVC_CNTT | Image | varbinary | |
InvoiceTotalAmount | The total monetary value of the CustomerAccountInvoice. | MO_INVC_TOT | MoneyShortRetail | decimal(7,2) | |
PaymentReceivedAmount | The total value of all payments received against this CustomerAccountInvoice. | MO_AMT_PYMT_RCV | MoneyShortRetail | decimal(7,2) | |
CreditMemoFlag | A boolean indicator that if set to YES means this CustomerAccountInvoice is a "negative" credit memo that represents a value to be subtracted from the total customer AR balance. The use of this flag is determined by the retailer and its application program logic. Refund PaymentOnAccountLineItem balances may be taken as individual "negative" line items in an invoice OR issued as separate CR MEMOs (negative invoices). This flag along with the PaymentOnAccountLineItem.RefundFlag gives retailers the ability to execute either approach to handling credits against their customer account balances due. | FL_CR_MMO | Flag | integer | |
Invoiced (FK) | A unique identifier for a customer account. | Invoiced | Identity | integer | CustomerOrderAccount(LE_CT_ORD_ACNT) |